package com.sti.platform.dao.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.aisino.core.dao.BaseDao;
import com.sti.platform.dao.ActDao;

@Repository
public class ActDaoImpl extends BaseDao implements ActDao {

	@Override
	public List<Map<String,Object>> getBusiness(String userId) {
		String sql="select * from tb_busioness  u where u.cjr = '" + userId + "'";
		@SuppressWarnings("unchecked")
		List<Map<String,Object>> list =super.getBySql(sql,HashMap.class );
		return list;
	}
	
	@Override
	public List<Map<String, Object>> getActInfoByYwId(String ywId){
		String  sql="select * from act_user_lcsl u where u.yw_id = '" + ywId +"'";
		@SuppressWarnings("unchecked")
		List<Map<String, Object>> list =super.getBySql(sql,HashMap.class );
		return list;
	}

	@Override
	public List<Map<String, Object>> getBusinessByLcslId(String lcslId) {
		String sql = "select * from act_user_lcsl u where u.lcsl_id = '" +lcslId + "'";
		@SuppressWarnings("unchecked")
		List<Map<String,Object>> list =super.getBySql(sql,HashMap.class );
		return list;
	}

	@Override
	public List<Map<String,Object>> queryOpinion(String lcslId){
		String sql = "select * from tb_opinion u where u.lcsl_id = '" + lcslId + "'";
		@SuppressWarnings("unchecked")
		List<Map<String,Object>> list =super.getBySql(sql,HashMap.class );
		return list;
	}
	
	
}
